Viewing 15 posts - 1,351 through 1,365 (of 3,232 total)
Is this a single user application? If not, how do you plan to keep the global temp table name unique for the thread that is creating it?
Using global temp...
July 6, 2009 at 12:05 pm
What on Earth does that mean?
I'm sure if you can describe your problem in a way that we can understand what you are trying to do, someone can help you....
July 6, 2009 at 11:54 am
I'm looking forward to reading it!
July 6, 2009 at 9:29 am
Yes, that may help, but I think you'll still have some challenges to deal with. Data flows are coupled closely to the metadata returned by a source adapter. ...
July 6, 2009 at 9:28 am
OK. SSIS will not be able to resolve the metadata from a dynamic query so you'll need another approach. If you are trying to cut down on development...
July 2, 2009 at 12:18 pm
Source adapters in your data flow cannot be dynamic. They must return the exact same metadata each time they run and the SSIS validation routine must be able to...
July 2, 2009 at 10:08 am
Florian Reischl (7/1/2009)
First:
Your sample data contain:
101656 05/05/09 5' 6.5" 66.50
101656 05/05/09
101656 05/05/09 5' 5.75" 65.75
101656 05/12/09
101656 05/27/09
There is no uniqueness...
July 1, 2009 at 5:27 pm
DECLARE @Table TABLE (cust_id int, date datetime, height varchar(10), weight varchar(10))
INSERT INTO @Table
SELECT 1, '01/01/2009', '5''2', '110lbs' UNION ALL
SELECT 1, '01/02/2009', NULL, NULL UNION ALL
SELECT 1, '01/03/2009', NULL, NULL...
July 1, 2009 at 3:11 pm
Yep, great articles. Once you've generated trace data, it's just a matter of loading the trace data into a table where you can group/sum/search for the processes responsible for...
July 1, 2009 at 9:22 am
I'll ask again, is there a reason why you need to use a Script component as your source to read from a flat file? It sounds to me like...
July 1, 2009 at 9:19 am
You are 'unable' to run it on your other 2 servers? What does 'unable' mean? Do you get errors, do you not have access to the servers? ...
June 30, 2009 at 9:22 am
DECLARE @Address TABLE(Zip varchar(10), PlusFour varchar(4))
INSERT INTO @Address
SELECT '68114', NULL UNION ALL
SELECT '68132', '1234'
SELECT ZIP + CASE WHEN LEN(PlusFour) > 0 THEN '-'+PlusFour ELSE '' END AS FullZIP
FROM @Address
June 29, 2009 at 2:43 pm
So you're using the Script Component as the source? Have you considered using a flat file conection manager instead?
June 29, 2009 at 2:02 pm
Pretty straight forward concept, but we'll need sample data and schema to really help out here. From a high level perspective, here's what you'll need.
INSERT INTO DestinationTableName(Col1, Col2, Col3)
SELECT...
June 29, 2009 at 1:09 pm
OK, here's what you'll need to do.
1. Set up a For Each Loop Container in your control flow.
-- Collection tab settings
...
June 29, 2009 at 10:54 am
Viewing 15 posts - 1,351 through 1,365 (of 3,232 total)