etl.laptop (10/15/2013)

---

A situation caused an error. I need to fix that.

Error -

[Execute SQL Task] Error: Failed to acquire connection "MyDBConnection". Connection may not be configured correctly or you may...

Should you decide to throw in a Pig and a Donkey as well, I'd suggest resorting to a lookup table rather than expanding out the code to a nesting nightmare.

Nevyn (10/15/2013)

---

Phil Parkin (10/13/2013)

---

Well, I think we are drifting into a grey semantic area here.

SSIS natively...

g_demetriou (10/15/2013)

---

Hi,

is there a way via SSIS to create a table to match a file's headers (which can change), and then load that data into the table? I've been looking...

I’m using c# code from a SQLcentral article- Using XML from data variable option in SSIS (http://www.sqlservercentral.com/articles/SQL+Server/97947/) which works perfectly with the original webservice address but when I change the...

If you've processed a file with a dynamic name, you must already have the file name in a variable. Use that in the FST.

Well, I think we are drifting into a grey semantic area here.

SSIS natively provides the flexibility...

manibad (10/13/2013)

---

thanks...

A brief Google search led me to this [/url]article.

It's not difficult, but it's much easier (and almost certainly faster) if you can do this in T-SQL instead.

1 - you know java well

C#

2 - want to develop code quickly

C# is less verbose

3 - easy for beginners

VB.NET has the edge here, IMO

4 - has most functionality for...

Same as what?

Please justify this comment. Because I can think of a way of doing this without staging tables.

etl.laptop (9/26/2013)

---

I made a practice problem for myself - Using SSIS, make a package to load data from text files located on a Server P, load these files into a...

etl.laptop (9/26/2013)

---

I want to make a package to load some text files into a database table. Any suggestions on how I can check if a file has been loaded already...

How about this?