Hi Paul,
Thanks for your clue. I went to destination source editor and set the location where it needs to be. Execution went OK. When I work with other databases like adventureworks / adventureworksDW, unless we fix the destination, we always see a red cross in the destination component of the...
Hi Forum,
I have been practicing a Microsoft SSIS 2005. In the sample data; I got a pckage called 'creatlist'. When I execute the package as per their instructions in the book, It shows red color in the flat file destination folder - employee.csv. It says execution failure with a maximum error...
Hi Paul,
Thanks for your suggestion and questioning the actual existence of the table. I found upon verification those tables were missing in the SMS - database - tables. I found those missing tables in the my documents along with others as mdf files and asking me to manually attach. I did not...
I try to fis these by going to source editor. But when I click the column in the connection manager - error appears and could not click OK
Thanks, please guide me further.
Hi Paul,
Thank you for attention. This is sample database came in the CD with Book MS SQL 2005 SSIS.
When I see the screen shots in the book, those triangels and red crosses are not present.
that means I tempted to think that somewhere I mishandled the procedure.
Even I reloaded the data...
Hi
I am newbie in the SQL. I am learning with book called Microsoft SSIS step by step.
I am practicing the sample data supplied with the book. I really need your patience to solve my problem
Q.1) When I open a sample package ‘ createlist’ in the BIDS,
I found yellow triangles in the objects...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.