higgsboson99 (6/12/2012)

---

Thanks, I got it working and am now able to observe the values being set in the Watch window. The backslashes are getting doubled up. Is this...

higgsboson99 (6/12/2012)

---

Here is the code I am using to set the variables. Am I assigning values correctly? (I know values themselves are correct.)

Public Sub Main()

...

higgsboson99 (6/11/2012)

---

Hi all,

I'm new to SSIS. I've created a data flow task that will import an Excel (.xlsx) file into a database on my SQL Server. The filename...

Do you mean DTS or SSIS?

Probably.

You've been here long enough to know the score - please provide sample input and output data etc etc.

tbraithwaite (6/8/2012)

---

I've also just discovered that if I give the full path to the source DB and run the query from that DB is also gives the leading zeros.

Rather strange,...

Sorry, but thank you for making me laugh with this sign-off :w00t:

Your post is one of the least clear I have read in quite a...

Please follow the link in my signature - it describes how best to post such questions.

Unless you provide more details, it will be very difficult to provide you with...

Does the Excel file already exist? I think it needs to. Stick with CSV if you can and save yourself a few headaches 🙂

opc.three (6/5/2012)

---

I do not think you can delete Excel data using an OLE DB connection but I read you can use the DROP TABLE followed by CREATE TABLE syntax to...

Please answer my other questions and justify the use of SSIS.

Nidhi G (6/5/2012)

---

Hi,

I need to create a package in SSIS 2008 for the following task:

I have a database name OMB. In that database i have different schemas like bau,ssi,stg etc..

I...

May I ask why you are not using a fixed-width flat file source connection in SSIS - that will do all of the splitting for you?

To answer your question...

Presumably you keep the files? If so, you can check for yourself, surely?

Or are you saying that the files themselves are fine and that the errors are occuring elsewhere in...

hamsa_apj (6/5/2012)

---

Thanks for your response.

Its is fixed length file and am splitting the data using subString(), to map the data from .dat file to database table columns. Since position of...