The Temple of Fu

code, systems and games

Archive for November 2010

SSIS – File mapping object ‘Global\DTSQLIMPORT’ could not be opened. Operating system error code 2(The system cannot find the file specified.). Make sure you are accessing a local server via Windows security.

with 2 comments

Man one of these days Microsoft will make these error messages easier to understand. I am one of the ones that came from DTS land where after a few years things became comfortable; but in an effort to make things easier for us Microsoft gave us SQL Server Integration Services (SSIS) to overcome some of the DTS package shortcomings. Well they made my life a living hell in trying to learn this, well at least this particular task /rant.

The latest in my struggles is trying to deduce from the garbage that are SSIS messages what exactly I need to do to fix my error. The most recent being:
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT ' could not be opened. Operating system error code 2(The system cannot find the file specified.). Make sure you are accessing a local server via Windows security.".

What was I trying to do I will represent in this complicated flowchart.
Excel document –> SQL Server table

Confused yet? Me neither, If I were to do this with a DTS package it would have taken an hour tops but currently I am going on 4 hours! Not only am I battling Excel and it’s ‘here let me make this easier for you and guess what types or lengths your columns can hold’ productivity enhancements. I am also needing to deduce these bs error messages that are given at freaking runtime from within BIDS designer!
/rant #2

OK so the actual fix now is; instead of using a SQL Destination (even though you are inserting into SQL wtf) use an OLE DB Destination. The reason being to use a SQL destination you need to run the package on the machine that hosts SQL Server (destination). If you want to use a remote SQL Server, use OLEDB destination.

Hope that helps.

Written by lordfu

November 5, 2010 at 4:33 pm

Posted in Development, MSSQL, SSIS

CentOS 5* VSFTPD Install and Setup + OpenSSL

leave a comment »

Install VSFTPD
# yum install vsftpd

Turn on the VSFTPD service so it starts at boot
# chkconfig vsftpd on

Start, stop or restart VSFTPD
# service vsftpd [start,stop,restart]

Generate an OpenSSL certificate

You use OpenSSL to generate a certificate for vsftpd. The certificate is stored on your server, in a location of your choice. Here I choose to put it in the /etc/vsftpd directory. As well, you specify a ‘lifetime’ for the certificate; here it is set for 5 years (“-days 1825”).Note that the backslashes only signify line breaks. You should be able to copy/paste & run it as it is, or remove the backslashes and the line breaks.
If /etc/vsftpd does not exist create it (it existed on my system after install).
#mkdir /etc/vsftpd

#openssl req -x509 -nodes -days 1825 -newkey rsa:1024 \
-keyout /etc/vsftpd/vsftpd.pem \
-out /etc/vsftpd/vsftpd.pem

You will be prompted with a series of question, which you answer as they appear. When done the certificate will be installed in the /etc/vsftpd directory.

To configure vsftpd you need to edit the file /etc/vsftpd/vsftpd.conf and add the following lines:
ssl_enable=YES
allow_anon_ssl=NO
force_local_data_ssl=NO
force_local_logins_ssl=NO
ssl_tlsv1=YES
ssl_sslv2=NO
ssl_sslv3=NO
rsa_cert_file=/etc/vsftpd/vsftpd.pem

Restart vsftpd for these settings to take effect:
#/etc/rc.d/init.d/vsftpd restart

Connect using a ftp client that support AUTH TLS / SSL / SFTP I use FileZilla.

Error Messages (below answers are what worked for me YMMV):
Connection attempt failed with “ECONNREFUSED – Connection refused by server”.
Provide correct info for login and port within your client.

Status: Connection established, initializing TLS…
Error: Connection timed out

I indicated the server type in my client as “FTPS – FTP over implicit TLS/SSL” but it must be “FTPES – FTP over explicit TLS/SSL” for it to work

Error: GnuTLS error -8: A record packet with illegal version was received.
Error: Disconnected from server: ECONNABORTED – Connection aborted

Verify vsftpd.conf settings are correct.

Written by lordfu

November 2, 2010 at 10:46 am

Posted in Linux, RedHats