Data Flow in SSIS Tutorial (5/25)

While running task, shows Unable to start program DTS is showing i can't run the task, i have followed the same installation steps from the vedio, can you pls help me?

Hi Nagi, have seen all your videos on power bi, ssis and your videos helped me alot. Just a request could you please make a playlist on Oracle Bi?

your Tendulkar of of SQL and data warehouse ..... really awesome enjoyed every line of yours

Thanks for vídeo 👌

Thank you So Much...I have created my first SSIS package with your help......

Hi Nag garu, How you have crated SSIS data base in SSMS.
Naaku flat file nunchi, ole db connect chese tappudu, "component OLE DB source has no inputs" error vasthundi..

Where i download your content files?

Thanks for the video, if I am using SQLExpress, then I dont have the feature of creating tables dynamically?

What do we need to select if the file type is excel?

One of the best teacher for me really love and admire you Sir for your videos

5/25

Not good teaching its very mess 🙄

Is these videos are enough to learn ssis or else need to learn anything sir..please reply me sir

Hi It was a great video . I have a query how this activity is different from SQL Server Import Export ? because this can also import/export data from one place to another .

Hello Naga Jee!

is possible for you explian me these error which I got it while loading some flat file to OLE DB?

Error: 0xC02020A1 at Data Flow Task, Flat File Source [2]: Data conversion failed. The data conversion for column "collection_amt" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
Error: 0xC02020A1 at Data Flow Task, Flat File Source 1 [63]: Data conversion failed. The data conversion for column "ce_score_pd" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
Error: 0xC0209029 at Data Flow Task, Flat File Source [2]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Flat File Source.Outputs[Flat File Source Output].Columns[collection_amt]" failed because error code 0xC0209084 occurred, and the error row disposition on "Flat File Source.Outputs[Flat File Source Output].Columns[collection_amt]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
Error: 0xC0209029 at Data Flow Task, Flat File Source 1 [63]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Flat File Source 1.Outputs[Flat File Source Output].Columns[ce_score_pd]" failed because error code 0xC0209084 occurred, and the error row disposition on "Flat File Source 1.Outputs[Flat File Source Output].Columns[ce_score_pd]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
Error: 0xC0202092 at Data Flow Task, Flat File Source [2]: An error occurred while processing file "D:\Statistics assigments\melissaleej77\ACCOUNT_INFO.csv" on data row 131.
Error: 0xC0202092 at Data Flow Task, Flat File Source 1 [63]: An error occurred while processing file "D:\Statistics assigments\melissaleej77\SCORE_INFO.csv" on data row 5072.
Error: 0xC0047038 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Flat File Source returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
Error: 0xC0047038 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Flat File Source 1 returned error code 0xC0202092. The component returned a failure code when the pipeline engine c

Hello !
where can i find the folder containing ur files ?

whydid we use both ssdt and ssms, did you use ssms for creating database, tables and ssdt for etl?

how to execute script task with code can u explain it briefly with real time scenarios

what is variables , parameters, logging and their importance in real time and y should we use