Viewing 15 posts - 1,261 through 1,275 (of 2,612 total)
You could write a CLR stored procedure.
If you do this, I think you may need to enable unsafe assemblies - I don't think the system IO namespace is allowed otherwise.
June 17, 2008 at 11:28 am
The most effective solution would probably be to display the results of:
EXEC sp_helpdb
June 17, 2008 at 11:26 am
Yes, you can chain subscriptions like this.
Remember that replication is not designed as a DR solution. By default, foreign keys, identity column definitions, and a few other things do...
June 17, 2008 at 11:12 am
If you have FK relationships between the destination tbales, you will probably have a lot of trouble with a single data flow and a multicast. The problem will be...
June 17, 2008 at 10:26 am
Change the design - just kidding.
You are in trouble - mostly because of the issue you presented. Even in your sample data, MIKE SMITH and STEVE JONES are impossible...
June 17, 2008 at 10:21 am
Ok, so it sounds like you have one source (flat file) and three destination tables. For each row in the source, you want one row in each destination table....
June 17, 2008 at 9:53 am
You can limit the database engine that the SSRS databases are running on, but that will not limit SSRS for using memory. SSIS runs as a service and within...
June 17, 2008 at 9:42 am
That's a pretty general question. Some detail would help.
In SSIS, you can use a Multicast component to duplicate your data flow if you need some data to go to...
June 17, 2008 at 9:37 am
Search google for some sample code.
You have some alternatives. You can create a linked server from your SQL Server to the AS400. Also, you are likely to find...
June 17, 2008 at 9:28 am
Some things do not seem to report all that well, but wait stats report correctly. You may have an argument if you show your team wait stats that are...
June 17, 2008 at 9:25 am
The CTE's are not necessary, they just made the syntax look nice.
[font="Courier New"]; WITH Data1 (Id, [Name], I)
AS (
SELECT Id, Name, ROW_NUMBER() OVER (ORDER BY Id) FROM addr
) , Data2...
June 17, 2008 at 8:47 am
Oddly enough - there is no ODBC destination adaptor. You will need to use a script component in your data flow. When you drag it out, you will...
June 17, 2008 at 8:40 am
Yes, if you can get the data into either a single row or a single column in just one pre-determined sheet, SSIS will pretty easily allow you to connect to...
June 17, 2008 at 8:32 am
I am not sure how you got from migrating a cube to the subject of DTS. Perhaps you have some of your terms wrong - I do not understand...
June 17, 2008 at 8:01 am
Viewing 15 posts - 1,261 through 1,275 (of 2,612 total)