Forum Replies Created

Viewing 15 posts - 181 through 195 (of 1,118 total)

  • RE: Processing XLS Files

    James Tech (2/24/2011)

    CozyRoc (2/24/2011)

    You have to use the script in the standard Script Task. I would recommend you find good book about SSIS.

    Okay, I already got it. My only problem...

    February 24, 2011 at 11:59 am

    #1291179

  • RE: Processing XLS Files

    You have to use the script in the standard Script Task. I would recommend you find good book about SSIS.

    February 24, 2011 at 11:39 am

    #1291156

  • RE: Processing XLS Files

    Do you have any sample reference where I can see how to implement the items you suggested?

    What I have right now is an SSIS package which contains "Foreach Loop Container"...

    February 24, 2011 at 11:09 am

    #1291143

  • RE: Looping SSIS on database query

    ben-732740 (2/23/2011)

    I'd use triggers, but only in combination with Service Broker. I don't like putting anything as heavy as starting a job in a trigger. Plus, what happens if the...

    February 24, 2011 at 9:33 am

    #1291068

  • RE: Processing XLS Files

    James Tech (2/24/2011)

    Hi everyone.

    How do I create an SSIS package that will process the following items?

    - Scan all the excel files from a given folder (*.xls).

    - Get the latest excel...

    February 24, 2011 at 9:25 am

    #1291066

  • RE: Is it possible to send Data to an excel spreadsheet with multiple tabs

    dndaughtery (2/24/2011)

    I am wanting move data from an oledb src which is pulling records which are sorted by specific column say ColA. I'd like to send the data to an...

    February 24, 2011 at 9:21 am

    #1291061

  • RE: Extracting XML FROM a table

    wildh (2/21/2011)

    Here’s the situation. I have a table and one of the fields contains XML with numerous elements in it. I want to be able to separate those elements into...

    February 24, 2011 at 9:13 am

    #1291058

  • RE: XML file to Import into a table column

    pamozer (2/18/2011)

    I currently have an xml file that I import into multiple tables using the xml source. That is working fine. I need to also store the actual xml...

    February 24, 2011 at 9:10 am

    #1291055

  • RE: Regarding Excel File Using For Each Loop

    maverick_immortal (2/16/2011)

    Hi I have two excel files in one folder Member 1 and member 2 the file names are different but the data inside is the same. Thats fine.

    I am...

    February 17, 2011 at 11:47 am

    #1288425

  • RE: Send Mail Task is not Working

    Kumar,

    Can you provide more details like error messages or something? It is not very clear what is not working.

    February 10, 2011 at 5:18 am

    #1285087

  • RE: FTP task - getting x bytes uploaded

    Abhijit More (2/2/2011)

    Hey!

    I have wiered situation here

    I have cretaed one package which uploads the files on specific server using FTP task. One of our organization requirement is they want to...

    February 10, 2011 at 5:17 am

    #1285086

  • RE: how to extract compressed folders?

    abhas (2/10/2011)

    Hi,

    I am having a folder say folder1 and in that folder another folder's which are compressed folders.I want to extract that compressed folders.These folders are compressed by built in...

    February 10, 2011 at 5:13 am

    #1285085

  • RE: file watcher task no custom editor

    jyothi_siri2000 (2/3/2011)

    actually i am getting only the properties window in file watcher task how could it possible to support the custom editor.

    by this i could not declare any variable.

    Your post...

    February 4, 2011 at 7:30 am

    #1282465

  • RE: How to load data while creating missing lookups as well in a data flow?

    What you are trying to do is called "surrogate key generation" and it is pretty standard process in SSIS. Check the following articles:

    Generating Surrogate Keys

    Surrogate key generation in SSIS

    Generating Surrogate-Keys...

    February 4, 2011 at 7:24 am

    #1282455

  • RE: Custom Transformation

    rocky_498 (1/31/2011)

    Hi guys,

    Is any one can help me how and from where i can download "ADDRESS PARSE TRANSFORM".

    Thanks.

    The original Address Parse transform is available here. There is optional...

    February 4, 2011 at 7:15 am

    #1282448

Viewing 15 posts - 181 through 195 (of 1,118 total)