Step-by-step article here:

http://technet.microsoft.com/en-us/library/ms143724.aspx

Dan

SQL King (2/19/2008)

I would take ALL the above replies into considerations. But then, you also wanted current time in your CSV right? This can be generated by adding a derieved...

Glad to help.

If you're trying to insert into an existing table:

You can't use "SELECT INTO" with an existing table. You need to do an "INSERT INTO".

"SELECT INTO"...

You want one character field, correct? Here you go:

SELECT CONVERT(CHAR(5), GETDATE()-7, 110) + ' - ' + CONVERT(CHAR(5), GETDATE(), 110)

Just replace the "GETDATE()" part with the dates you want...

Does the 'XR' table contain BillingTypes that are an empty string as well?

You're joining from PS to XR, and then from XR to NN. It would be...

I used to do that direct interface as well, but migrated to the method I pasted above because I kept running into variable locking issues. (I can't remember exactly...

guybornn,

Once you make sure your variable is set correctly by the script, you use the control flow to decide what to do next. (The little green arrow that comes...

I'm not sure precisely what you're asking, but I'll give it a shot...

You can use a variable defined by an expression.

I assume the package knows which location it is dealing...

Everything is a pasted image - if you paste the actual text I would have time to help you. I don't have the bandwidth to do the OCR and...

I need a little bit more info...

1. There are several syntax errors in the script that I can see

a. Your cast for StartTime is missing a closing parenthesis

...

I've done this in a couple of ways - I'll try and give you a place to start...

1. Create a variable (scoped to the whole SSIS package) which will contain...

The Kimball Group website (http://www.kimballgroup.com) is also a great source for some fundamental articles.

Dan

Thanks Stefan.

I've decided that the ship-to data isn't part of the customer at all. It's a part of the order. I'll be creating a new dimension table for...

One of two possible things:

1) Are you running SQL Standard or Enterprise? Only enterprise allows data-driven subscriptions.

2) If you're running Enterprise, RDP onto the box that has reporting services...