Forum Replies Created

Viewing 15 posts - 16 through 30 (of 53 total)

  • RE: Phone Numbers in Excel being loaded as NULL to SQL Server

    Phil Parkin (5/16/2011)

    When it come to mapping of SSIS data type and SQL Server datatype then nchar, nvarchar, sql_variant, xml will be mapped directly to DT_WSTR (SSIS data type). Any...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 16, 2011 at 10:23 pm

    #1325573

  • RE: Phone Numbers in Excel being loaded as NULL to SQL Server

    Ninja's_RGR'us (5/16/2011)

    Anjan Wahwar (5/15/2011)

    Convert to "Unicode String [DT_WSTR]" instead of [DT_STR]

    What's the difference between the 2? >>> never used ssis b4.

    Addition to the difference given by phil:

    When it...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 16, 2011 at 7:25 am

    #1325022

  • RE: Phone Numbers in Excel being loaded as NULL to SQL Server

    Convert to "Unicode String [DT_WSTR]" instead of [DT_STR]

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 15, 2011 at 11:32 pm

    #1324855

  • RE: Appropriate data flow to load related tables

    radb4u (5/13/2011)

    Thank you for the response. Lookup is required for the package but I want to know the flow of the data. In short I have the following tables which...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 15, 2011 at 11:10 pm

    #1324854

  • RE: SSIS package parameters

    Why not you go for passing 2 parameters that will take value from GETDATE()-7 days to GETDATE()-1 day . This will be better approach than creating table as changing schema...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 13, 2011 at 4:41 am

    #1324178

  • RE: Appropriate data flow to load related tables

    Need to detail as your requirement is not pretty clear ..

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 13, 2011 at 4:27 am

    #1324167

  • RE: SSIS :: HOW TO: Check if a flat-file has records in it

    If I got your problem correctly then this is the One way to do that:

    Write the last modified date in your err-output.txt file. Then at the end of your package...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 24, 2011 at 3:36 am

    #1315236

  • RE: File System task

    Use expressions to generate folder name at run time in the format Name_MMDDYYYY instead of giving hard coded value.

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 23, 2011 at 12:01 am

    #1315091

  • RE: How to Deploy the SSIS Package

    @Koen

    I also want to know the same. It seems, by mistake you gave this post link only.

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 21, 2011 at 5:41 am

    #1314430

  • RE: How to give versioning to my folder in SSIS using FST

    Bhavika, What is this FST by the way

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 20, 2011 at 11:46 am

    #1314137

  • RE: Can we create folders and files dynamically using ssis ?

    Hi,

    One way to do is like this way-

    1) Drag n Drop a FileSystem task to the SSIS workflow.

    2) Edit it. Specify source and destination connection (Any hard coded excel file...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 18, 2011 at 10:23 am

    #1312935

  • RE: Can we create folders and files dynamically using ssis ?

    bhavika.chauhan (4/18/2011)

    Hi,

    While exporting the data , i need to send it to Excel file. While doing so i want to Create a specific folder and then save the excel file...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 18, 2011 at 12:50 am

    #1312612

  • RE: Incompatible data types

    You can't change the data type to DT_WSTR directly in the excel source. Better to use Data Type Conversion transformation to transform input into DT_WSTR, which are not supported by...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 16, 2011 at 11:53 am

    #1312449

  • RE: Conversion from DTS to SSIS 2005/2008

    Elliott Whitlow (4/15/2011)

    I agree, you don't need to know DTS intimately. The wizard does ok, but will usually no do a very good job with even a slightly complex package...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 16, 2011 at 11:33 am

    #1312445

  • RE: Which SSIS transformation to used

    bhavika.chauhan (4/15/2011)

    Can you let me know how to use Aggregate transformation to remove duplicate. I tried using Aggregate but it just gave me count of all the columns .

    See the...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 15, 2011 at 8:12 am

    #1312163

Viewing 15 posts - 16 through 30 (of 53 total)