I think you might have wanted to put a different question. That one is mine.

Can...

I'll try this - http://msdn.microsoft.com/en-us/library/ms140033(v=sql.105).aspx

How to: Debug a Script by Setting Breakpoints in a Script Task

Lempster (1/6/2014)

---

Yes, you can do that. What is your Execute SQL task doing? If you are returning a count of the rows in the ResultSet as part of the SQL...

my mistake. resolved.

Kannan Vignesh (1/3/2014)

---

hi,

i am Kannan. i need tmplate for loading flat files into staging as well as historical simultaneously. now i am currently using data flow transformation in for each...

Lowell (12/30/2013)

---

my working code for the same functionality is largely the same;

i think you'll need to try-catch and get the inner exception and see what the server/connection issue is;

I just...

Did you try to search google for an answer ? Try this and see if it works -

http://stackoverflow.com/questions/10905044/ssis-transfer-database-task-cryptic-error-message-0x80131500

Sorry, I am not able to understand your question. Please explain it clearly.

Yes, I gave up and decided to use an OLEDB connection instead. Still wondering why I got that error though. Google searches did...

GilaMonster (9/14/2010)

---

There's no fixed set of questions, different companies will ask different questions. Memorising questions is not the way to go about preparing for an interview. A good interviewer can...

I guess it would be better to google "ssis package running slowly" or something like that and read each post to learn reasons for slow execution. Some links I got...

@Evil Kraig F - From my experience, it does not really help much if you get a fully-loaded, paid version of any ETL tool and some paid tutorials/books.

To be...

Evil Kraig F (12/19/2013)

---

There's no particular list. It's an open ended question to see how much you know about SSIS package execution and where all the pain points you've...

Thanks for all the tips @Evil Kraig F. I made a child package which will accept a DataSet from a parent package and convert it into a CSV file. Since...