Dave R (UK) (2/20/2014)

---

Thanks for the prompt response Phil,

I have looked at the script component, but couldn't get the condition to work...the number of splits will be totally dynamic and...

Dave R (UK) (2/20/2014)

---

Hi all,

I've been looking for the last couple of days, but have been unable to find a solution.

Situation:

I need to load and split a text file, however...

smasihullah (2/18/2014)

---

Hello,

I'm trying to publish a workbook in Tableau and its giving the the message.

Database error 0x80040154. class not registered.

Drivers necessary to connect to the database server fdxsql........\INST1 are not...

Koen Verbeeck (2/17/2014)

---

Maybe you can monitor the log? Or kick off a monotoring script in parallel with your data flow.

You insert a row into a log table before and after...

That...

What do you mean by this?

abhas (2/14/2014)

---

Hi All,

My source file is coma separated file having 6 columns. But some times two lines are merging i.e. eow containas 12 columns instead of 6 and my package...

jevogelsong (2/13/2014)

---

I think you got me in the right direction. The package was a SQL Server package not a file system. I used this package and saved a 2nd version...

jevogelsong (2/13/2014)

---

It was a existing package I am trying to edit so I would assume so. Please mind any ignorance on my part I only have a minor in SQL,...

jevogelsong (2/11/2014)

---

Hello,

I have a SQL server using a scheduled job to call a SSIS package which copies tables from one server to another. I was asked to add a few...

Koen Verbeeck (2/11/2014)

---

Maybe you want to make a system that fails gracefully when a file is not present.

The easiest method imo is to use a script task, where you can...

And if that fails, you could also try MSDB 😀

Koen Verbeeck (2/11/2014)

---

The code is easier than you might think:

File.GetCreationTime Method

I would store the result in an SSIS variable and populate a column in the data flow using a derived...

The above assumes that:

a) You have created appropriate output columns for your script component

b) That the script component is running in synchronous mode (one row in = one row out)

It is possible, but I'm not going to write the code for you - unless you want to hire...