SQL Server is Freaking a Brain Dead Retartded Piece of Cabbage
-
This is rant, and pure :mad: rant, not programming or admin question. I have just tried to export a table to a fixed length field file, and after everything, at the end of the wizard, when I run the package, :mad: I get told 'Failed to write out column name for column "ShortLocation"'. What the fruk is wrong or hard to write out about that name? :mad: :mad::mad: I'm asking SQL to write the stuff, not read it. It's freaking on ITS terms! :mad::mad::mad: So, I try and see if it dislikes all columns after column n, and delete "ShortLocation" and several adjacent colums, and I get the same fraking error, for a non-existent column. :mad: Then, I delete every single column except the pkid, "SiteId", an int column, and it pukes up this error, ' Cannot copy or convert flat file data for column "SiteId"'. What the fruck does that mean? Like I said, it's doing the writing!!! :mad::mad::mad::mad::mad::mad::mad::mad: So I skip column names and it skips newlines, giving me a literally fixed width only file. I can parse that, but FFS! Surely this isn't such a bleeding challenge to simply include a simple export ability in a million dollar DBMS?
I have been trying for weeks to get this little site indexed. If you wonder what it is, or would like some informal accommodation for the 2010 World Cup, please click on this link for Rhino Cottages.
-
This is rant, and pure :mad: rant, not programming or admin question. I have just tried to export a table to a fixed length field file, and after everything, at the end of the wizard, when I run the package, :mad: I get told 'Failed to write out column name for column "ShortLocation"'. What the fruk is wrong or hard to write out about that name? :mad: :mad::mad: I'm asking SQL to write the stuff, not read it. It's freaking on ITS terms! :mad::mad::mad: So, I try and see if it dislikes all columns after column n, and delete "ShortLocation" and several adjacent colums, and I get the same fraking error, for a non-existent column. :mad: Then, I delete every single column except the pkid, "SiteId", an int column, and it pukes up this error, ' Cannot copy or convert flat file data for column "SiteId"'. What the fruck does that mean? Like I said, it's doing the writing!!! :mad::mad::mad::mad::mad::mad::mad::mad: So I skip column names and it skips newlines, giving me a literally fixed width only file. I can parse that, but FFS! Surely this isn't such a bleeding challenge to simply include a simple export ability in a million dollar DBMS?
I have been trying for weeks to get this little site indexed. If you wonder what it is, or would like some informal accommodation for the 2010 World Cup, please click on this link for Rhino Cottages.
Slow down. you're going to get a heart attack. I think there is an option to choose unicode when exporting to a flat file. Try that.
Cheers Garth I don't really care whether or not i really care or not.
-
This is rant, and pure :mad: rant, not programming or admin question. I have just tried to export a table to a fixed length field file, and after everything, at the end of the wizard, when I run the package, :mad: I get told 'Failed to write out column name for column "ShortLocation"'. What the fruk is wrong or hard to write out about that name? :mad: :mad::mad: I'm asking SQL to write the stuff, not read it. It's freaking on ITS terms! :mad::mad::mad: So, I try and see if it dislikes all columns after column n, and delete "ShortLocation" and several adjacent colums, and I get the same fraking error, for a non-existent column. :mad: Then, I delete every single column except the pkid, "SiteId", an int column, and it pukes up this error, ' Cannot copy or convert flat file data for column "SiteId"'. What the fruck does that mean? Like I said, it's doing the writing!!! :mad::mad::mad::mad::mad::mad::mad::mad: So I skip column names and it skips newlines, giving me a literally fixed width only file. I can parse that, but FFS! Surely this isn't such a bleeding challenge to simply include a simple export ability in a million dollar DBMS?
I have been trying for weeks to get this little site indexed. If you wonder what it is, or would like some informal accommodation for the 2010 World Cup, please click on this link for Rhino Cottages.
Your general :mad: is how I feel about both Python and Subversion right now.
-
Slow down. you're going to get a heart attack. I think there is an option to choose unicode when exporting to a flat file. Try that.
Cheers Garth I don't really care whether or not i really care or not.
I already tried that. I'm manually crafting an SSIS package now.
-
Your general :mad: is how I feel about both Python and Subversion right now.
Subversion I can sympathise as well. It may be reliable, but it's as stupid as all hell.
I have been trying for weeks to get this little site indexed. If you wonder what it is, or would like some informal accommodation for the 2010 World Cup, please click on this link for Rhino Cottages.
-
This is rant, and pure :mad: rant, not programming or admin question. I have just tried to export a table to a fixed length field file, and after everything, at the end of the wizard, when I run the package, :mad: I get told 'Failed to write out column name for column "ShortLocation"'. What the fruk is wrong or hard to write out about that name? :mad: :mad::mad: I'm asking SQL to write the stuff, not read it. It's freaking on ITS terms! :mad::mad::mad: So, I try and see if it dislikes all columns after column n, and delete "ShortLocation" and several adjacent colums, and I get the same fraking error, for a non-existent column. :mad: Then, I delete every single column except the pkid, "SiteId", an int column, and it pukes up this error, ' Cannot copy or convert flat file data for column "SiteId"'. What the fruck does that mean? Like I said, it's doing the writing!!! :mad::mad::mad::mad::mad::mad::mad::mad: So I skip column names and it skips newlines, giving me a literally fixed width only file. I can parse that, but FFS! Surely this isn't such a bleeding challenge to simply include a simple export ability in a million dollar DBMS?
I have been trying for weeks to get this little site indexed. If you wonder what it is, or would like some informal accommodation for the 2010 World Cup, please click on this link for Rhino Cottages.
Don't know if it applies here but I ran into something similar recently. You have to have the full (enterprise I think) version of sql-management studio installed in order for the export / import wizard thingy to work properly (and even then it's dodgy at best).
-
Your general :mad: is how I feel about both Python and Subversion right now.
Tip of the day: moving files/folders around in the repository browser is much handier!
Wout
-
This is rant, and pure :mad: rant, not programming or admin question. I have just tried to export a table to a fixed length field file, and after everything, at the end of the wizard, when I run the package, :mad: I get told 'Failed to write out column name for column "ShortLocation"'. What the fruk is wrong or hard to write out about that name? :mad: :mad::mad: I'm asking SQL to write the stuff, not read it. It's freaking on ITS terms! :mad::mad::mad: So, I try and see if it dislikes all columns after column n, and delete "ShortLocation" and several adjacent colums, and I get the same fraking error, for a non-existent column. :mad: Then, I delete every single column except the pkid, "SiteId", an int column, and it pukes up this error, ' Cannot copy or convert flat file data for column "SiteId"'. What the fruck does that mean? Like I said, it's doing the writing!!! :mad::mad::mad::mad::mad::mad::mad::mad: So I skip column names and it skips newlines, giving me a literally fixed width only file. I can parse that, but FFS! Surely this isn't such a bleeding challenge to simply include a simple export ability in a million dollar DBMS?
I have been trying for weeks to get this little site indexed. If you wonder what it is, or would like some informal accommodation for the 2010 World Cup, please click on this link for Rhino Cottages.
I always roll my own. :rolleyes:
-
This is rant, and pure :mad: rant, not programming or admin question. I have just tried to export a table to a fixed length field file, and after everything, at the end of the wizard, when I run the package, :mad: I get told 'Failed to write out column name for column "ShortLocation"'. What the fruk is wrong or hard to write out about that name? :mad: :mad::mad: I'm asking SQL to write the stuff, not read it. It's freaking on ITS terms! :mad::mad::mad: So, I try and see if it dislikes all columns after column n, and delete "ShortLocation" and several adjacent colums, and I get the same fraking error, for a non-existent column. :mad: Then, I delete every single column except the pkid, "SiteId", an int column, and it pukes up this error, ' Cannot copy or convert flat file data for column "SiteId"'. What the fruck does that mean? Like I said, it's doing the writing!!! :mad::mad::mad::mad::mad::mad::mad::mad: So I skip column names and it skips newlines, giving me a literally fixed width only file. I can parse that, but FFS! Surely this isn't such a bleeding challenge to simply include a simple export ability in a million dollar DBMS?
I have been trying for weeks to get this little site indexed. If you wonder what it is, or would like some informal accommodation for the 2010 World Cup, please click on this link for Rhino Cottages.
-
This is rant, and pure :mad: rant, not programming or admin question. I have just tried to export a table to a fixed length field file, and after everything, at the end of the wizard, when I run the package, :mad: I get told 'Failed to write out column name for column "ShortLocation"'. What the fruk is wrong or hard to write out about that name? :mad: :mad::mad: I'm asking SQL to write the stuff, not read it. It's freaking on ITS terms! :mad::mad::mad: So, I try and see if it dislikes all columns after column n, and delete "ShortLocation" and several adjacent colums, and I get the same fraking error, for a non-existent column. :mad: Then, I delete every single column except the pkid, "SiteId", an int column, and it pukes up this error, ' Cannot copy or convert flat file data for column "SiteId"'. What the fruck does that mean? Like I said, it's doing the writing!!! :mad::mad::mad::mad::mad::mad::mad::mad: So I skip column names and it skips newlines, giving me a literally fixed width only file. I can parse that, but FFS! Surely this isn't such a bleeding challenge to simply include a simple export ability in a million dollar DBMS?
I have been trying for weeks to get this little site indexed. If you wonder what it is, or would like some informal accommodation for the 2010 World Cup, please click on this link for Rhino Cottages.
Yeah... sound too familiar, good is that I'm not working with MSSQL anymore :-)
------------------------------------------------------------ Want to be happy - do what you like!