BitBucket...that worked great!.. very good workaround...quick to implement. Still want to get a good handle on the DTS design/runtime object model though...but for now...this will keep me going...thanks again...

thanks for the reply Paul...the earlier suggestion with a linked server works great... I just need my DBA to create the linked server in our dev environment (permission issue)..However, in...

i just re-read your post...The select into would work...but the data is coming from excel.. its not yet in SQL server... so im thinking i need to import it first...

whatever will work...however, using insert into requires me to know what columns are 'in coming'. I will not know this. Is there something in your suggestion i am...

I have a similiar issue Paul, I need to load from excel where the columns will vary on each import into an OLEDB destination. I have been wrestling with...