Viewing 15 posts - 4,756 through 4,770 (of 7,191 total)
OK, so Integration Services is running under NT AUTHORITY\NETWORK SERVICE? Does that have access to SQL Server, either in its own right or through something like BUILTIN\Administrators?
John
February 3, 2012 at 4:29 am
Does your server name really have a "v" at the end, or is there a type in your config file?
John
February 3, 2012 at 4:22 am
A few more questions. Can you connect to the database engine through SSMS? You say you're on SQL Server 2008 R2. 32 bit or 64 bit? ...
February 3, 2012 at 4:14 am
Sounds as if it's something to do with the MsDtsSrvr.ini.xml file. Maybe it did get confused by what you did with the named instance. Are you able to...
February 3, 2012 at 3:59 am
I wonder why SSIS is mentioned in the error message, then. Are you trying to expand a folder under Maintenance Plans?
Check you've got the correct instance name. I...
February 3, 2012 at 3:50 am
I take it you're using BIDS? Are you doing so on the same computer that SQL Server is on? What happens if you try to connect using SSMS?
John
February 3, 2012 at 3:34 am
How many instances of SQL Server do you have on the computer?
John
February 3, 2012 at 3:03 am
Please will you provide DDL for your table, along with sample data. Depending on your data types, you could use mathematical functions, or a CASE expression.
John
February 3, 2012 at 2:00 am
I think it's just GETDATE(). In the expression builder, you can drag the functions you want to use from the tree above. No need to cast a function...
February 2, 2012 at 9:25 am
Two options that come to mind:
(1) Use the Derived Column transformation in your data flow
(2) When extracting the data from the source tables, use a SQL query as your source,...
February 2, 2012 at 8:52 am
Then you have two options:
(1) Get all the data into a staging table and update it with an Execute SQL task
(2) Use my original suggestion.
John
February 2, 2012 at 5:30 am
Greg
Like I said, you're going to have problems on the boundaries, and in part it will depend on your business rules. For example, do you want to compare hour...
February 2, 2012 at 5:23 am
simhadriraju (2/2/2012)
February 2, 2012 at 5:13 am
Or you could set up a variable with the "function" logic in it, and use that in your expression. I prefer Koen's method, I think - if something can...
February 2, 2012 at 5:10 am
Jon
I take it you didn't run the final EXEC statement, since that generates an error? The reason is that you have DECLAREd all your variables instead of making them...
February 2, 2012 at 5:05 am
Viewing 15 posts - 4,756 through 4,770 (of 7,191 total)