she's sending the data table Programatically...

thx for that clarification Greg.. also derived this info:

*** We can also include a custom created --> db_executor priveledge w/in these Roles (see definition below) which will set each Role...

Microsoft Change, Configuration, Release Management:

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

Using Phil's suggestion to utilize an Expression, my solution was:

- created new variable at Pkg level; I named it: SQLStatement

- Highlighted the variable 'SQLStatement' and viewed...

worked great. Thank you Phil.

I use an expression for my CONNECTION STRING in previous tasks that look like:

@[User::BaseFolder] + @[User::BaseTypeFolder] + @[User::BaseFile] + @[User::pActiveDate] + ".TXT"

Question is, how do I relay this expression to...

Migrating DTS to SQL 2008

-------------------------

To port your SQL 2000 DTS packages onto your SQL 2008 instance, you'll want to backup up your SQL 2000 msdb then restore it onto your...

I've built an SSIS 2008 package incorporating the 'Transfer Logins Task'

Think I found my issue. I'm invoking the SSIS pkg from a stored proc via DTEXEC.. passing multiple variables into the proc (sourced from a VB GUI)

The proc in...

Yes.. still getting an error.

I used this mechanism to wrap double quotes around my variable:

"\"" + @[User::pDestPathFile] + "\""

My Variable value is: C:\TRASH\My Trash\My Trash Folder\MyTrash.csv

(Evaluating the above expression renders:...

I've attached the actual SQL statement below. If I comment out the SELECT MAX section, the statement parses appropriately.

/*****

AND (VV.Fund_Valuation_Date =

(SELECT MAX (Fund_Valuation_Date) FROM dbo.Fund_Valuation VVV

...

thanks for the feedback. Unfortunately, we are stuck w/ the SQL as is (it's a huge, 15 table join, using correlated sub-selects w/ a nested SELECT MAX function.. It...

your solution worked like a charm.. thanks Erik..

thx Kev - that worked just fine!

Your solution worked perfectly for my last scenario (convertng MMDDYY to YYYYMMDD)

Now I have the inverse scenario.. I need T-SQL to convert the character 8 format "YYYYMMDD" to a character...