Hello, First timer here. I'm having an issue when I use a date variable to set the 'between dates'. The query works when when I replace the variable w/ static dates. I get all r …

Hello, I have created a job which I pass two variables through as follows: DTSRUN /Sqh-sql2 /N"UnisoftVB" /AgvAccessDatabase :8="Y:\InformationCopy.mdb" /AgvAccessForm :8= "frmImp …

I have a variable called RouteCallerKeyDay and it takes a value such as '149421' which is calculated with the expression 148960 + DATEDIFF(dd, '2008-11-03 00:00:00', '2010-02-07 00 …

Hi, I am painfully new to SSRS and have an assignment to create a report that will render based on the userID; I have the report built and the stored procedure that brings in all …

Hi I am having a unique problem. I am not able to open my variable tab in SSIS designer I have tried Right clicking and then selecting Variables and from SSIS menu but nothing work …

I am using a flat file to read the data and load into SQL Server. How can I populate one of the fields on the table with a variable that is available in the package but not in the …

Can I do the following, and use an @variable in an IN predicate? DECLARE @Vendor varchar(1000), @VendorID varchar(1000) SET @Vendor = 'Smith' SET @VendorID = '' IF @Vendor = 'Sm …

How can I (in SSIS) put into variables something from SQL table or query? Jack Woo