swethak13 (7/22/2011)

---

I had a file in text format (fixed length) to upload into a table. I have used SSIS package to insert data from .txt to SQL.I am working on...

rgtft (10/5/2011)

---

If you save the flat file connection after marking the first few (or 20) fields, it will just assume that the last field is really long. You can...

Marios Philippopoulos (9/21/2011)

---

One more thing: get rid of the dashes in the "Data Source" name.

This might very well be the issue.

I have had this issue with the "-" characters...

Hi, In the DataSources tab, I added the Password.

It looks like I need to modify the command-line arguments, any idea how.

It gives me error argument '***' for option 'connection '...

Marios Philippopoulos (9/21/2011)

---

Do any of your data sources in the job (DataSources tab) use sql auth to connect to the instance? If yes, you will need to manually re-enter the...

prvmine (9/9/2011)

---

Yes you can transfer data from one server to another with an SSIS Package.

Would suggest creating the package with SQL Server 2008 BIDS and deploying to the SQL 2008...

Kevin Dahl (9/21/2011)

---

It could be that they're doing something in addition to the text encoding, or maybe they've modified the original to create their own encoding method. You're probably best...

<quote>A better option may be to use an SSIS script task and find a simple C# or VB implementation of uudecode (I found a C# one here, for instance) -...

That looks like UUEncoding, I'm not sure how you'd decode that in SQL. There are command line utilities to uudecode data though, so if you're using SSIS maybe you could...

The PDF file data in the nText column of the 3rd-party application looks like this-->

begin 660 O M)5!$1BTQ+C0-)>+CS],-"C<R(#`@;V)J#3Pa+TQI;F5A<FEZ960@,2],(#8R M,3,W-B]/(#<T+T4@-3(Y-30O3B`Y+U0@-C(P.3,Y+T@@6R`T.#@@,3@U73X^

I think it is encoded , because it is starting with...

Kevin Dahl (9/14/2011)

---

Is it possible that in the ntext -> nvarchar conversion something got truncated? nvarchar has a max of 4000 characters, which is not an awful lot of space...

<quote>I'm apparently not being clear. The binary data tha Acrobat needs is already GONE, when it was placed into the nText. This data will never work in Acrobat...

Can the currently stored data in the nText field in 2k5 be used in Acrobat? If not, the data will not suddenly 'work' if you move it to a...

Hi,

I did not understand what do you mean by-->...

The nText field works with Acrobat? usually you'd use an image field in the older versions to deal with external file types.VARCHAR(Max) will NEVER work once it's in there....