Viewing 15 posts - 12,616 through 12,630 (of 13,849 total)
Also check that the BudgetFilePath variable has been set so that it points to a valid file so that SSIS's meta-data validation does not fail.
July 17, 2009 at 12:34 am
Ah yes - that copy line was causing me pain because my file system does not have the path you were using, so I muted it 🙂
Change your Evaluation: Expression...
July 16, 2009 at 10:24 pm
Try this:
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Public Class ScriptMain
Public Sub Main()
Dim FileSource As String, FileDestination As String
Dim file As FileIO.FileSystem
...
July 16, 2009 at 7:16 pm
Interesting. Can you give me an example of what your source file variable contains?
July 16, 2009 at 10:18 am
jim (7/16/2009)
July 16, 2009 at 8:48 am
ryan213 (7/16/2009)
Do I need to change anything in that script? I'm pretty sure I followed everything. I created a string variable called SourceFile that contains the location/filename...
July 16, 2009 at 8:42 am
Huh? Are you talking about a row-by-row comparison, or something else? What do you mean by binary - are you referring to a checksum?
More detail needed about why you are...
July 16, 2009 at 8:17 am
You should not need a script.
Configure a flat file connection, setting the format to 'fixed width' and then set all your start positions and lengths ...
July 16, 2009 at 8:14 am
No problem. Just a script task is needed to take the variable containing the file name and do the file copy for you. This would be on the Control Flow,...
July 16, 2009 at 8:10 am
Whoa, what is that!? 😀
I'm assuming that 12345 is just dummy data and not some obscure representation of a date (number of days since a blue moon,...
July 16, 2009 at 3:56 am
I agree with your findings - it's as if the insert happens and then rolls back, using up a number in the process.
I do not know whether that behaviour can...
July 16, 2009 at 3:48 am
Assume that you have a Boolean variable called Test. Here is how you would set it to True using a Script Task.
1) Create a Script Task.
2) Add 'User::Test' (no quotes)...
July 15, 2009 at 9:20 pm
touchmeknot123 (7/15/2009)
Hi,I am developing the SSIS package to parse a non-delimited file.
Can you please help me on the script which is to be written to parse the file ?
Thanks
This should...
July 15, 2009 at 9:12 pm
Here is how I would do it, I think.
1. Ensure that there is a string variable defined (eg SourceFile) which contains the filepath of the source data (eg C:\Ryan\Output_.xls)
2. Create...
July 15, 2009 at 9:03 pm
Viewing 15 posts - 12,616 through 12,630 (of 13,849 total)