Viewing 15 posts - 31 through 45 (of 58 total)
The funny thing is, if you have both versions installed and you double click on a SSIS project, it is 2010 that opens. Yeah, the one that doesn't work... :crazy:
"Future...
March 4, 2011 at 2:38 pm
I'm not sure in a SS2008 / VS2008 environment ... think I saw some posts about a CTP6 that had something to do with that, but I'm not positive (would...
March 4, 2011 at 1:13 pm
All you should need to do is install SQL Server 2008 Standard (or higher, or use the Dev edition). BIDS is essentially a shelled-VS environment that is part of...
March 4, 2011 at 10:08 am
Exactly what Koen said: packages and solutions are incompatible between VS versions. Once you upgrade a package or solution by bringing it into VS2008, you're unable to edit it...
March 4, 2011 at 8:55 am
I'm not familiar with the 850 file spec, but x12 834/835s are essentially a single line when the raw file is viewed ... I'm guessing that an x12 850 is...
March 3, 2011 at 3:56 pm
Alvin-
Not sure where you're at in your progress, but in our processing of 834/835 files, we use home-grown parser apps to break the files down into more of a flat-file...
March 2, 2011 at 10:38 am
Yup - from what we've seen/researched, those seem to work fine ... think the main issue is the configuration loading, specifically, in 2008 with the design configs being re-loaded at...
February 24, 2011 at 10:58 am
As opc mentioned, check the package's protection ... unless you're using passwords and security with your packages and their deployment, it's probably best/easier to set your package ProtectionLevel to DontSaveSensitve,...
February 24, 2011 at 7:44 am
Something to consider is which version of SQL Server/SSIS you're using ... configs behave and load a little differently in 2008 than in 2005 if you're running via dtexec and...
February 24, 2011 at 7:39 am
If you'r able to convert the original excel file into a flat file of some format, you can opt to skip any number of data rows and/or the header row,...
October 27, 2010 at 10:12 am
An alternative is to use PowerShell: you can read in the original flat file, count the number of old delimiters in the header/top-most record, and the replace each of the...
October 14, 2010 at 7:56 am
Another plus in the SP column is that if you have reusable sql in the Exec SQL task that is used in multiple packages (assuming no common child package is...
September 22, 2010 at 7:45 am
Not sure if this was your solution, or not, but when copying packages, it's a good idea to reset the GUIDs in the new copy of the package to refresh...
September 20, 2010 at 10:10 am
I'm not familiar with using Cozy sw specifically, but in your ForEachLoop (FEL) container, you end up assigning your "wildcarded" file name into some variable (like, CurrentFlie, for example), with...
July 23, 2010 at 9:03 am
7-zip is also a pretty solid archiving utility (and free) with a good command line interface which is easy to parameterize in SSIS.
July 21, 2010 at 8:26 am
Viewing 15 posts - 31 through 45 (of 58 total)