DSXchange

Many transformations, no concats.

Yes, sequential file stage. DOS Style. Missing columns action: Pad with SQL Null Delimiter: , Quote character: " Default Null String Blank Default padding: # Just a note. I can click the view data button and see the first line just fine.

Yes, if I move the row to the end it processes fine and the new first row has the issue. I have deleted the first row and the new first row has the issue as well. All other rows in the file load fine. Sorry for the confusion but it's hard to explain something that logically shouldn't happen.

I have a job that moves data from a sequential file to a SQL Server (2002). On the first row and only the first row I get an "Invalid character value for cast specification" error. This is what I have done so far to fix the problem. I haved moved the first row to the end and created a new ...

Well, I suddenly it's fixed. Now, I can't tell you how it got fixed because everyone is saying they didn't do anything but I don't believe this. I have been complaining for weeks, saying that this is a network or server problem and now all of the sudden it's fixed. So thanks for any help you provide...

I finally got the client installed on the server and can login without problems. I have re-started the service on the server and I still have the same problem. I had our network team put a sniffer on network and the packet is being delivered to the server and returned to the client fine but I still ...

Sorry I have not responded. I am in the process of getting the client installed on the server. Large company, too many politics. Once I get it installed I will check to see if it works.

Anyway, when I check the omit button it logs me in every time.

I need help with an error. When I try to login to DataStage (Any of the 4 products) I am getting the following error. Failed to connect to host: ... (User name and/or password incorrect(80011)) This has been happening since we installed the package a few weeks ago. I have confirmed that the user nam...