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...

How many files are we talking about and also how many different layouts?

Multiple data flows (one per file type) is one way of handling this.

Another is to send all of...

Please explain what you mean by this.

In general, for every different file format, you will need a separate dataflow. Multiple files with...

Can you explain in more detail what do you mean by this bit please?

Scott Coleman (2/6/2014)

---

I was just making the observation that the original post did not say where the data was coming from or where it was going. However clever the...

You seem to be...

battula.ramu6 (2/6/2014)

---

When I use calculation in generating reports, I get Nan,#Error,Infinity values in preview , I wanted to avoid this and display " " if the result of calculation...

chetan.deshpande001 (2/6/2014)

---

Would it be ok for you to use recursive CTE ? ..something like

--Edit

I'm sorry for the formatting/colors ..as this is my first post and do not know how...

Certainly a good opportunity for you to learn. I am no PoSh guru by any...