How did you "build" your package?

Can you be a bit more specific?

Also, I'm not your personal Google. Most of this stuff can easily be found by browsing Google/Bing a bit.

Is Publication_Author a view?

Can you post the definition of that table?

This seems very unlikely.

Can you post screenshots? (you can add attachments to your post. Look at the post options when you are typing a reply)

tommyh (9/6/2012)

---

Worthless question because of the fact that you add something that doesnt really relate to the question. The key part in the question is the "GO 5" part. And...

Yes, but the article I linked contains pretty much all...

Can you use the webservice to get the file?

Does the website have a webservice that you can use to download the file?

Or an FTP server?

If you need to download it over http:

Downloading a file over HTTP the SSIS...

If your source is SQL Server, you can just add the ROWNUMBER() function to your query.

If you really want to use the variable, you need a script component, not a...

Thanks for this question on the basics Ron.

I would recommend you to go through Exam Policy first. Microsoft will ban the candidate if he/she violates any of the following rules.

Candidate bans

If a candidate violates any testing rule,...

Which processing mode do you use?

Do you have partitions? Do you need to refresh data that is 3 years old? I would think you'd need only to process the last...

There's no set definition of BI, but the one from...

It seems odd you want to store this values in the table.

This means values of a row are dependant on other rows. Not sure this is good design.

For example, if...

Great question Wayne.