{"action":"closed","issue":{"url":"https://api.github.com/repos/wliu-levansoft/media-coding/issues/37","labels_url":"https://api.github.com/repos/wliu-levansoft/media-coding/issues/37/labels{/name}","comments_url":"https://api.github.com/repos/wliu-levansoft/media-coding/issues/37/comments","events_url":"https://api.github.com/repos/wliu-levansoft/media-coding/issues/37/events","html_url":"https://github.com/wliu-levansoft/media-coding/issues/37","id":56572915,"number":37,"title":"import excel into MS SQL Server Management Studio","user":{"login":"mrsminiberger","id":7119634,"avatar_url":"https://avatars.githubusercontent.com/u/7119634?v=3","gravatar_id":"","url":"https://api.github.com/users/mrsminiberger","html_url":"https://github.com/mrsminiberger","followers_url":"https://api.github.com/users/mrsminiberger/followers","following_url":"https://api.github.com/users/mrsminiberger/following{/other_user}","gists_url":"https://api.github.com/users/mrsminiberger/gists{/gist_id}","starred_url":"https://api.github.com/users/mrsminiberger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrsminiberger/subscriptions","organizations_url":"https://api.github.com/users/mrsminiberger/orgs","repos_url":"https://api.github.com/users/mrsminiberger/repos","events_url":"https://api.github.com/users/mrsminiberger/events{/privacy}","received_events_url":"https://api.github.com/users/mrsminiberger/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-02-04T19:13:18Z","updated_at":"2015-02-05T08:52:22Z","closed_at":"2015-02-05T08:52:22Z","body":"Can you tell me what I'm doing wrong? I need to update the \"gross\" variable in the movie table. I created an excel spreadsheet with the data I need. I use the import wizard in management Studio to import into the Temp_import database I created. By all rights, it LOOKS Like it works fine... no errors. The right number of rows importing, but the tables are just NOT THERE. Could it be sticking it somewhere else? Pasting the status report: \r\n\r\nThe execution was successful\r\n\r\n- Initializing Data Flow Task (Success)\r\n\r\n- Initializing Connections (Success)\r\n\r\n- Setting SQL Command (Success)\r\n\r\n- Setting Source Connection (Success)\r\n\r\n- Setting Destination Connection (Success)\r\n\r\n- Validating (Success)\r\n\r\n- Prepare for Execute (Success)\r\n\r\n- Pre-execute (Success)\r\n\r\n- Executing (Success)\r\n\r\n- Copying to [Temp_import].[dbo].[1] (Success)\r\n2367 rows transferred \r\n\r\nMessages\r\nInformation 0x402090df: Data Flow Task: The final commit for the data insertion has started.\r\n (SQL Server Import and Export Wizard)\r\n \r\n\r\n- Copying to [Temp_import].[dbo].['1$'] (Success)\r\n2367 rows transferred \r\n\r\nMessages\r\nInformation 0x402090df: Data Flow Task: The final commit for the data insertion has started.\r\n (SQL Server Import and Export Wizard)\r\n \r\nInformation 0x402090e0: Data Flow Task: The final commit for the data insertion has ended.\r\n (SQL Server Import and Export Wizard)\r\n \r\nInformation 0x402090e0: Data Flow Task: The final commit for the data insertion has ended.\r\n (SQL Server Import and Export Wizard)\r\n \r\n\r\n- Post-execute (Success)\r\n\r\n- Cleanup (Success)\r\nMessages\r\nInformation 0x4004300b: Data Flow Task: \"component \"Destination - 1\" (20)\" wrote 2367 rows.\r\n (SQL Server Import and Export Wizard)\r\n \r\nInformation 0x4004300b: Data Flow Task: \"component \"Destination 1 - '1$'\" (61)\" wrote 2367 rows.\r\n (SQL Server Import and Export Wizard)\r\n \r\n"}}