Samer: Sorry for all of the questions!

What exactly is happening in the current state if you open the file? And what do you WANT to happen? ...

s.mousharrafieh (11/8/2010)

---

The file is too big to manually replace the blank spaces and I cannot use the trim function since it needs to be applied on a certain field rather...

Two things to check out:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64585/

http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-ssis/2422/Failure-to-set-up-OLE-DB-from-SSIS-2005-to-Excel-2007

Was your old machine 32-bit and new one 64-bit?

Pakorn Pankasem (11/8/2010)

---

Hi wanlapa linlawan

When you help someone please understand what they need!!! or what is problme!!!

You are head of DB and Bi so you should read more....

I interview you...

I'm editing my post. I just tried to do what you are doing in SSIS and I can't figure out a way to merge data without a common key...

I think you are overcomplicating the solution by adding a script task. I think the easiest solution would be to create two separate jobs that run at different times...

Make sure your SQL Server Job Agent account has permissions to access the FTP/file paths.

Look into adding logging to your packages. Google it...there are a ton of resources out there to do this. You should be able to get exactly what you need.

reymon26 (11/5/2010)

---

hI,

Please help me about this problem,,

1) Does the SSIS can handel files such as VMS files from oracel,

2) .bat files

3) exe files made from vb.net

4)...

Martin Schoombee (11/5/2010)

---

Hi,

A good principle to follow when designing fact tables, is to always store the data at the more granular level. You can always aggregate up, but never down,...

It appears that the variable that you are passing into your parameter is of a different datatype than your SolOrderID. I would check both the variable and the SolOrderID...

If DB3 is varchar and DB2 is varchar then you don't need a data conversion component at all... Perhaps you're trying to convert when you don't need to?

I'm sure someone else has better advice, but one idea would be:

Do a check on the variable that gets populated by the filename each time the loop runs. Check...

Peter,

Thank you for the link and I would definitely be interested in seeing an example! I'm sure I would create packages programmatically if it came a little easier. ...