Forum Replies Created

Viewing 15 posts - 46 through 60 (of 163 total)

  • RE: SSIS,file Exist and Package Exit

    Please provide more details. How are you attempting to move the files? etc

  • RE: Remove Commas from CSV file

    Can your data ever have quotes within quotes?

    e.g. "This is a ""test"""

  • RE: Remove Commas from CSV file

    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...

  • RE: Remove Commas from CSV file

    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...

  • RE: How to map a network drive by using Skript task?

    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...

  • RE: Use VS Solutions with Projects or not?

    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,...

  • RE: Unzip files without CozyRoc + SSIS

    Or you could use a Script Task and call an external zipping library such as SharpZipLib.

  • RE: Windows Logon

    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...

  • RE: Executing SSIS Package from VB.NET

    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...

  • RE: problem in bids

    Try repairing your installation of visual studio / BIDS in control panel if the option is there.

  • RE: Calling WCF service from SQL CLR Stored procedure

    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...

  • RE: How to use my Variables?

    I'd do the concatenation, file exist check and file copy in a Script Task.

  • RE: Task for Zipping Files?

    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...

  • RE: SendMail Task dynamic file name

    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...

  • RE: Import a zip file from a HTTP page

    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...

Viewing 15 posts - 46 through 60 (of 163 total)