vishal.gamji (2/3/2009)

---

Can you add another ExecuteSQLTask that executes the query:

SELECT ? = TOP 1 1 FROM

create a variable for the ? and change the resultset of this execute...

Can you add another ExecuteSQLTask that executes the query:

SELECT ? = TOP 1 1 FROM

create a variable for the ? and change the resultset of this execute sql...

Isn't the difference of the dates that you supplied a year... a bit confusing??

Did u try assigning to the Config variable specifically:

Dts.Variables(" ").Value.ToString()

You could have used a merge join to join the Excel data source and add another data source (sql srvr) where you have your countries source. Join on the CountryKey,...

By now you might already know about the different deployment modes: File System and SQL Server (msdb), if you dont do lookup "Creating a SSIS manifest" and "Microsoft Project Real"....

Give this user LEFDOMAIN\jespinosa access to db_dtsoperator in msdb database. Are you using proxy to run the job?

There is another way. Assign the following access privileges to the user\owner running the job

msdb --> Security --> Roles --> Database Roles --> db_dtsoperator

create a role and assign your...

First step: Cut off developer access to production.

here is what i would recomment. Have the following cofiguration structure:

1. Create and environment variable (indirect XML config - generate from package)...

Tim Mitchell (1/30/2009)

---

My understanding is that there are possible performance implications with runtime as well as design time. I haven't done any runtime comparisons, so I'm speaking purely academically...

Tim, i do agree that it poses a performance issue - but only at design time ... right? or does it (FMTONLY) also have an impact at run time?

If you refer to microsoft project real's best practices that will help you. In general it it up to you to add comments and labelling to your control flows and...

Change result set mode to text.

🙂

Remove the * from the inner select and use the column to compare.

Is your database\server installation configured for mixed mode or only windows authentication? If so change the authentication mode to mixed mode and try.