here's some:

http://www.jumpstarttv.com/Channel.aspx?cat=4a80fb97-198c-4277-ac24-e2cc77d53561

Not free, but cheap:

http://www.learnintegrationservices.com/VideoTutorials/

I recently had to do something similar and I have always used NOT EXISTS correlated subqueries. I experimented with several methods (sub query, outer join, in ()) and found something...

If you are using SQL 2005, can you use row_number() instead of the identity column?

Something like:

INSERT@ECFMaster (RowID , ECFID , Effective)

SELECTROW_NUMBER() OVER (ORDER BY ECF_ID,corrected_Effective_Date ),

ECF_ID,

corrected_Effective_Date

FROMEffectivereports.Effectivereports.ECFIndiaMaster

WHEREEmp_ID=@Emp_ID

You may be able to copy and paste the file spec and create a script to build a table with the required structure.

Then upload the file into a single column...

Can you dynamically construct a bcp statement?

Tommy Bollhofer (10/2/2007)

---

Hi Emily,

Is there an FW between the MSSQL server and the SMTP relay? If this is the case, can you confirm w/ IT that TCP 25 is open...

Do you have to update or can you insert ?

INSERT cross_tab_table

select id,

sum(CASE WHEN MM = 1 THEN TotalAmount ELSE 0 END) as JAN_TOTAL,

sum(CASE WHEN MM =...

I think you need to define relationships between the tables; foreign key/primary keys in the actual database or on the data source view.

If you are looking for training materials, you might consider looking here:

http://www.learnsqlserver.com/VideoTutorials/

http://www.learnintegrationservices.com/

I havent used any of the videos so I dont know how good they are, but they are...