Monday, July 17, 2017

SSIS - SSIS Naming conventions

Task namePrefixTypeNew
For Loop ContainerFLCContainer
Foreach Loop ContainerFELCContainer
Sequence ContainerSEQCContainer
ActiveX ScriptAXSTask
Analysis Services Execute DDL TaskASETask
Analysis Services Processing TaskASPTask
Azure Blob Download TaskADTTask*
Azure Blob Upload TaskAUTTask*
Azure HDInsight Create Cluster TaskACCTTask*
Azure HDInsight Delete Cluster TaskACDTTask*
Azure HDInsight Hive TaskAHTTask*
Azure HDInsight Pig TaskAPTTask*
Back Up Database TaskBACKUPTask*
Bulk Insert TaskBLKTask
CDC Control TaskCDCTask*
Check Database Integrity TaskCHECKDBTask*
Data Flow TaskDFTTask
Data Mining Query TaskDMQTask
Data Profiling TaskDPTTask*
Execute Package TaskEPTTask
Execute Process TaskEPRTask
Execute SQL Server Agent Job TaskAGENTTask*
Execute SQL TaskSQLTask
Execute T-SQL Statement TaskTSQLTask*
Expression TaskEXPRTask
File System TaskFSYSTask
FTP TaskFTPTask
Hadoop File System TaskHFSYSTask*
Hadoop Hive TaskHIVETask*
Hadoop Pig TaskPIGTask*
History Cleanup TaskHISTCTTask*
Maintenance Cleanup TaskMAINCTTask*
Message Queue TaskMSMQTask
Notify Operator TaskNOTTask*
Rebuild Index TaskREBITTask*
Reorganize Index TaskREOITTask*
Script TaskSCRTask
Send Mail TaskSMTTask
Shrink Database TaskSHRINKDBTask*
Transfer Database TaskTDBTask
Transfer Error Messages TaskTEMTask
Transfer Jobs TaskTJTTask
Transfer Logins TaskTLTTask
Transfer Master Stored Procedures TaskTSPTask
Transfer SQL Server Objects TaskTSOTask
Update Statistics TaskSTATTask*
Web Service TaskWSTTask
WMI Data Reader TaskWMIDTask
WMI Event Watcher TaskWMIETask
XML TaskXMLTask
Transformation namePrefixTypeNew
ADO NET SourceADO_SRCSource*
Azure Blob SourceAB_SRCSource*
CDC SourceCDC_SRCSource*
DataReader SourceDR_SRCSource
Excel SourceEX_SRCSource
Flat File SourceFF_SRCSource
HDFS File SourceHDFS_SRCSource*
OData SourceODATA_SRCSource*
ODBC SourceODBC_SRCSource*
OLE DB SourceOLE_SRCSource
Raw File SourceRF_SRCSource
SharePoint List SourceSPL_SRCSource
XML SourceXML_SRCSource
AggregateAGGTransformation
AuditAUDTransformation
Balanced Data DistributorBDDTransformation*
Cache TransformCCHTransformation*
CDC SplitterCDCSTransformation*
Character MapCHMTransformation
Conditional SplitCSPLTransformation
Copy ColumnCPYCTransformation
Data ConversionDCNVTransformation
Data Mining QueryDMQTransformation
Derived ColumnDERTransformation
DQS CleansingDQSCTransformation*
Export ColumnEXPCTransformation
Fuzzy GroupingFZGTransformation
Fuzzy LookupFZLTransformation
Import ColumnIMPCTransformation
LookupLKPTransformation
MergeMRGTransformation
Merge JoinMRGJTransformation
MulticastMLTTransformation
OLE DB CommandCMDTransformation
Percentage SamplingPSMPTransformation
PivotPVTTransformation
Row CountCNTTransformation
Row SamplingRSMPTransformation
Script ComponentSCRTransformation
Slowly Changing DimensionSCDTransformation
SortSRTTransformation
Term ExtractionTEXTransformation
Term LookupTELTransformation
Union AllALLTransformation
UnpivotUPVTTransformation
ADO NET DestinationADO_DSTDestination*
Azure Blob DestinationAB_DSTDestination*
Data Mining Model TrainingDMMT_DSTDestination
Data Streaming DestinationDS_DSTDestination*
DataReaderDestDR_DSTDestination
Dimension ProcessingDP_DSTDestination
Excel DestinationEX_DSTDestination
Flat File DestinationFF_DSTDestination
HDFS File DestinationHDFS_DSTDestination*
ODBC DestinationODBC_DSTDestination*
OLE DB DestinationOLE_DSTDestination
Partition ProcessingPP_DSTDestination
Raw File DestinationRF_DSTDestination
Recordset DestinationRS_DSTDestination
SharePoint List DestinationSPL_DSTDestination
SQL Server Compact DestinationSSC_DSTDestination*
SQL Server DestinationSS_DSTDestination


Example of the prefixes

No comments:

Search This Blog

DAX - Grouping on multiple columns and the count

Please go thorugh the below URL for entire soultion. http://community.powerbi.com/t5/Desktop/DAX-Grouping-on-multiple-columns-and-the-cou...