Viewing 15 posts - 46 through 60 (of 163 total)
Please provide more details. How are you attempting to move the files? etc
April 5, 2009 at 5:19 pm
Can your data ever have quotes within quotes?
e.g. "This is a ""test"""
March 12, 2009 at 7:50 pm
Oh and as far as I know SSIS (2005 anyway) doesn't deal with commas within quotes by default. You can write code in a script task obviously to do all...
March 12, 2009 at 4:54 pm
How large can the file be?
Will the file contain quotations around fields and if so, do you want to preserve the commas within the quotes?
e.g. value1,value2,"This is value3, hi!",value4
You could...
March 12, 2009 at 4:51 pm
You'll need to impersonate the other user account and then access the share as normal.
This will require a call to the LogonUser win32 api function (lives in advapi32.dll). This function...
March 9, 2009 at 4:46 pm
As far as I know you cannot open just a project in BIDS (aka Visual Studio). Even if you don't have a solution around the project to start off with,...
March 3, 2009 at 3:39 pm
Or you could use a Script Task and call an external zipping library such as SharpZipLib.
February 27, 2009 at 9:33 pm
I don't think any system variables will hold this info.
I believe you can capture the current user name in a Script Task (sample code shown below) and store it in...
February 12, 2009 at 3:32 pm
The first thing I can see is that you'll need to import a different namespace for SSIS. There are probably some other things that are different also. Have a look...
February 12, 2009 at 3:24 pm
Try repairing your installation of visual studio / BIDS in control panel if the option is there.
February 10, 2009 at 3:25 pm
One option is to expose an http endpoint in your wcf service and simply treat it as a web service from your clr stored proc (ie. add a Web Reference...
February 9, 2009 at 2:39 am
I'd do the concatenation, file exist check and file copy in a Script Task.
February 5, 2009 at 3:41 pm
You could also do it in a Script Task using a zipping library, such as the free SharpZipLib. You will have to put the SharpZipLib DLL in the GAC when...
January 28, 2009 at 4:22 pm
I don't understand your problem because at the end of your post you say:
"If I run the FTP Task fist.... then the Send mail... it works!!!"
Forgive me if I've misread...
January 26, 2009 at 3:35 pm
You could use a Script Task to do this. The classes in the System.Net namespace is what you will need. WebClient or even HttpWebRequest and HttpWebResponse classes. Just Google around...
January 21, 2009 at 4:10 pm
Viewing 15 posts - 46 through 60 (of 163 total)