Viewing 15 posts - 91 through 105 (of 3,232 total)
Duplicate post, continue here: http://www.sqlservercentral.com/Forums/Topic1777814-2799-1.aspx
April 14, 2016 at 9:46 am
Why don't you handle this in SSIS before you load the data? An expression on your pipeline column would fix this. The real question is, why do you...
April 13, 2016 at 2:45 pm
I said difficult, not impossible. This is as far as we're going to get w/o some more info from you on your process.
April 13, 2016 at 2:32 pm
Sean Lange (4/13/2016)
The next question is why are you storing dollar amounts as formatted text instead of decimals?
Agreed. Your original question asked for a simple way to convert you...
April 13, 2016 at 1:11 pm
If it's not a finite list, trying to run the load in parallel is going to be very difficult. Since you have to dynamically set the destination connection via...
April 13, 2016 at 1:04 pm
Where are the dynamic database names coming from? A table? Is it a finite list of destinations or will they need to be changed, added to?
Running the package...
April 13, 2016 at 11:26 am
So then the Destination database is changing? What part of the connection string is changing?
April 13, 2016 at 11:07 am
For the record, you would not install SQL Server on the Access machine. You'd run the package from the same SQL Server that you are trying to move the...
April 13, 2016 at 11:06 am
I didn't read all the way through this, but it's on a reliable site. A google search provides several examples....
April 13, 2016 at 10:46 am
You can easily sync your Access table w/ a SQL Server table via SSIS.
April 13, 2016 at 10:32 am
How are you determining the Destination servers? Are they a set group of servers, or will the destinations be changing?
April 13, 2016 at 10:30 am
I do lookups/merge joins against 1MM+ datasets all day long. With a SCD2, you're not going to be looking up against the whole table anyways. Your are always...
April 13, 2016 at 9:57 am
We have similar issues from time to time in our dev environment. If rebuilding statistics/indexes does not help, it may be a major difference in the data that is...
April 11, 2016 at 2:00 pm
Jeff Moden (4/8/2016)
John Rowan (4/7/2016)
April 8, 2016 at 1:09 pm
Glad to help. I'd definitely get your sales hat on. It's hard when analysts and business folks try to dictate data structures and how we store and serve...
April 7, 2016 at 11:26 am
Viewing 15 posts - 91 through 105 (of 3,232 total)