Alright so I have an Execute SQL Task that connects to a Foreach Loop container. The SQL Task queries a view that shows all the links but I cannot...

Here is an algorithm for what I want:

For each link in tblTables_And_Links

variable DownloadURL = link

open httpconnection(DownloadURL)

TodaysDate = now

If...

I have come across the same type of scenario. Administrative rights are a big factor in your ability to perform bulk inserts. For me at work, I have...

If your source file is delimited then chances are SSIS assigned too short of a length to one or more of the file fields. Look in the Flat File Connection...

I really appreciate your expertise on this matter. I am going to give your first suggestion a go as I think that it will be a helpful task in...

Alright, I think the issue might be that I have some duplicate values in the csv file trying to be passed into the PK fields. Is the csv file...

Hi Old Hand, rather than explain it, I have provided wikipedia links that describe what OLEDB, ADO, & ADO.NET are.

See OLEDB

See ADO

See ADO.NET

Sorry for such a late response, I've been working at learning SSIS more and have created a data flow task to do my editing for me. My dft contains...

Because that is the naming convention that I have learned.

I will get that to you as promptly as I can.

Hi opc.three and thanks. I'm not sure which file you would want me to upload but I am assuming it is the .csv so here it is. Bare...

Hi opc.three,

First off, thanks for the reply and yes you are right, I want to add a VBA macro to each csv file that will fire when opened. And...

Thanks again. Personally, when I count to 9 I'll start at 1 not 0. However, when it comes to programming, 0 is used as the first number in...

Thanks for your response. I agree with that logic but then why are there so many that would say 55 is the tenth I wonder?