Viewing 15 posts - 4,756 through 4,770 (of 7,187 total)
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
Amit
The row(s) you are inserting contain values that already exist in the table for the column(s) that make up your primary key. Search the internet for PRIMARY KEY if...
February 2, 2012 at 4:29 am
Greg
Your FROM clause is simpler than that:
FROM table t1 INNER JOIN table t2
ON t1.hour = t2.hour + 1
(I've kept it simple since all your sample data is for the same...
February 2, 2012 at 4:26 am
Amit
That's interesting. Do you have a question?
John
February 2, 2012 at 3:51 am
Do a self join on Hour = Hour + 1 and subtract one Monday from the other.
John
February 2, 2012 at 3:40 am
Viewing 15 posts - 4,756 through 4,770 (of 7,187 total)