Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: SQL Server agent jobs

    Gentlemen,

    I've run into this same error message (Unable to cast object of tyhpe 'Microsofot.SqlServer.Management.Smo.SimpleObjectKey' too type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey') since the install of SP2.  With SP1, I was able to create jobs...

  • RE: Flat File Data Conversion in SSIS package

    The file is generated by an outside source and imported to our system so I have very little to do with the format of the file (comma vs tab).  Getting...

  • RE: Flat File Data Conversion in SSIS package

    Selecting TAB as the seperator returns only one column from the file.  Additonally, all data points in the text file row may be empty until you get to the last two...

  • RE: Flat File Data Conversion in SSIS package

    First, Thank you for responding 

     

    The data in the csv file looks something like this:

    Date, Company Name, Account, Invoice No, Invoice Amt

    1/1/2005, "Company, Inc.", 12345, 12345678 RI, 1234.32

    1/2/2005, "Company, Inc.",...

Viewing 4 posts - 1 through 4 (of 4 total)