Never fear...

There is no such thing as a stupid question. EVER.

Really, when I started on SSIS (some 7 whole weeks ago) it took all of 3 weeks to deliver...

SUBSTRING also works in SSIS (*use as a derived column)

However, if you are saying that SSIS is reading your data in the incorrect format (mm/dd/yyyy as opposed to dd/mm/yyyy), perhaps...

laura.marshall (6/25/2008)

---

Hey don't you guys think you are being a "LITTLE BRUTAL?" - I'm sure you were not an EXPERT when you started out either! 🙂

I know I have...

😀

Awesome Jeff...

As for the SSIS bit, in this case I would have stayed away, no need, but Venki specifically asked how to do this in SSIS (call a SP from...

My problem is that working in South Africa we get attrocious bandwidth, and the other vid I tried didnt even open in my browser.

Will try again, but please dont shoot...

Is this...

Awesome

:D:D:D

I am bookmarking this posting and referring anyone with package configuration questions here.

Are you going to do one for SQL configs as well?

~PD

As stated before, its not possible to set the source, destination and transformation dynamically.

Closest you will get to that is to dynamically specify the connection, but little else.

Sorry man

Agreed, exec SQL would be the fastest, neatest method

hey,

First off, you want to import the filesystem reference in your scriping task

Imports System.IO.FileSystemInfo

should do the trick

Now you can reference this as following:

If Not (FileExists(YourFileName)) Then

....do some coding here

Else

...

That doesnt make sense.

I changed the connectionstring for an access db to a new mdb, and was able to re-use the metadata without a hitch.

The problem comes in when either...

Only a pleasure man.

Both these pieces of functionality are really simple to use, and most effective for what you are trying to achieve

~PD

Its great to hear an actual success story.

Very often everyone posts their problems, and after someone posts the solution they dont come back and say that it works/doesnt work....

Now for...

Correct

First data flow simply checks if there is data, and populates this check to a variable.

Second data flow is only executed if first one returns favorable results, and does the...

Now....

For the SSIS bit.

1) Create connectionmanager to your data

2) Create a preparation SQL task which basically deletes the data, as per the delete statement

3) Create a dataflow. OLEDB source to...