Viewing 15 posts - 121 through 135 (of 205 total)
You're right. I created two parent package configurations, one for each variable. Now I'm trying to figure out the "plumbing" of passing the variable values from parent to...
November 17, 2011 at 3:37 pm
This all worked well, thank you! Now for the next step. We want to turn the previously mentioned package into a parent package. And we want the...
November 17, 2011 at 2:49 pm
These are all great ideas. However, the requirement is that the SSIS packages iterate through a list of source and destination connections. If possible, the source/destination connection pair...
November 9, 2011 at 11:38 am
On local machine:
Microsoft SQL Server Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer8.0.6001.18702
Microsoft .NET Framework2.0.50727.3623
Operating...
October 11, 2011 at 10:41 am
Thanks, I already know about data viewers. I was just wondering if there was tool that literally shows the line backwards from the the destination column back to how...
August 25, 2011 at 12:17 pm
Oh, and you were absolutely right, there were naming conventions for the file names. Thank you so much!
May 24, 2011 at 7:16 pm
Here is what I ended up doing. I had the Foreach Loop put the file name in a variable. Then I had a script do the basically the...
May 24, 2011 at 7:16 pm
This is a good idea, except there will be many files in one format and many files in another format. I might be able to figure out what format...
May 24, 2011 at 1:19 pm
I typed the SELECT statement manually because I couldn't get a list of "tables" in the query builder.
April 19, 2011 at 3:42 pm
I'm using SQL Server 2008 R2 and Excel 2007. I hope this helps.
April 19, 2011 at 2:23 pm
I restarted BIDS and checked the permissions. I still get an error.
April 19, 2011 at 12:14 pm
I spoke too soon. When I try to run the package, I get the following error:
Error at Data Flow Task [Excel Source [29]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The...
April 19, 2011 at 11:58 am
I corrected the SQL syntax so now it works.
SELECT [POS Report-XXXX BRANDS-YYYYYYYY$].*
FROM ...
April 19, 2011 at 11:36 am
When I try the query builder I get the following error.
TITLE: Microsoft JET Database Engine
------------------------------
Unexpected error from external database driver (22).
------------------------------
BUTTONS:
&Retry
Cancel
------------------------------
April 19, 2011 at 11:25 am
Viewing 15 posts - 121 through 135 (of 205 total)